[dbo].[WarehouseCarrier]

Property	Value
Row Count	0
Created	10:31:43 AM Tuesday, March 02, 2010
Last Modified	11:40:10 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:43 AM Tuesday, March 02, 2010

Last Modified

11:40:10 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$	WarehouseKey	uniqueidentifier	16
$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$	ShipCarrierKey	uniqueidentifier	16
	CreatedByUserKey	uniqueidentifier	16
	CreatedOn	datetime	8	(getdate())

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$

WarehouseKey

uniqueidentifier

$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$

ShipCarrierKey

uniqueidentifier

CreatedByUserKey

uniqueidentifier

CreatedOn

datetime

(getdate())

	Name	Columns	Unique
$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$	PK_WarehouseCarrier	ShipCarrierKey, WarehouseKey
	IX_WarehouseCarrier_ShipCarrierKey	ShipCarrierKey

Name

Columns

Unique

$Cluster Primary Key PK_WarehouseCarrier: ShipCarrierKey\WarehouseKey$

PK_WarehouseCarrier

ShipCarrierKey, WarehouseKey

IX_WarehouseCarrier_ShipCarrierKey

ShipCarrierKey

Name	Columns
FK_WarehouseCarrier_UserMain_CreatedBy	CreatedByUserKey->[dbo].[UserMain].[UserKey]

Name

Columns

FK_WarehouseCarrier_UserMain_CreatedBy

CreatedByUserKey->[dbo].[UserMain].[UserKey]

SQL Script

CREATE TABLE [dbo].[WarehouseCarrier]
(
[WarehouseKey] [uniqueidentifier] NOT NULL,
[ShipCarrierKey] [uniqueidentifier] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_WarehouseCarrier_CreatedOn] DEFAULT (getdate())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[WarehouseCarrier] ADD CONSTRAINT [PK_WarehouseCarrier] PRIMARY KEY CLUSTERED ([ShipCarrierKey], [WarehouseKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WarehouseCarrier_ShipCarrierKey] ON [dbo].[WarehouseCarrier] ([ShipCarrierKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WarehouseCarrier] ADD CONSTRAINT [FK_WarehouseCarrier_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO